package com.smfx.yxt.daoSqlserver;

import java.util.List;

import com.smfx.yxt.model.KccsCourseStudentSign;
import com.smfx.yxt.page.Page;
import com.smfx.yxt.reqVo.BaseQueryVO;
import com.smfx.yxt.reqVo.KccsCourseQueryVO;
import com.smfx.yxt.reqVo.KccsStudentSignReqVO;
import com.smfx.yxt.view.KccsCourseStudentSignTotal;
import com.smfx.yxt.view.KccsCourseStudentSignView;

public interface KccsCourseStudentSignMapper {

    int insertSelective(KccsCourseStudentSign record);
    
    int insertSign(KccsStudentSignReqVO reqVO);
    
    int updateInvalidStudentSign(KccsStudentSignReqVO reqVO);

    KccsCourseStudentSign selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(KccsCourseStudentSign record);
    
    List<KccsCourseStudentSignView> selectSignedListForClass(KccsCourseQueryVO vo);
    
    List<KccsCourseStudentSignView> selectNoSignListForClass(KccsCourseQueryVO vo);
    
    KccsCourseStudentSignView selectSignedCourseForStudent(KccsCourseQueryVO vo);
    
    List<KccsCourseStudentSignView> selectSignListForParent(KccsCourseQueryVO vo);
    
    int seletCountByCourseId(BaseQueryVO vo);
    
    List<KccsCourseStudentSignView> selectSignListForTeachingByCourseId(KccsCourseQueryVO vo);
    
    List<KccsCourseStudentSignTotal> selectStudentSignListByPage(Page<KccsCourseStudentSignTotal> page);
    
    List<KccsCourseStudentSignTotal> selectCourseClazzTotal(KccsCourseQueryVO vo);
    
}